﻿using System;
using System.Collections.Generic;
using System.Text;
using System.Threading.Tasks;

namespace WebLog.Db.Update
{
    internal class update_v2_2 : baseUpdateDatabase
    {
        public update_v2_2()
        {
            this.V = 2.2;
            this.Memo = "添加sql跟踪表";
        }
        internal override async Task UpdateAction()
        {
            await sqliteHelper.ExecuteNonQueryAsync(@"
                    create table if not exists logSqls(
                        id integer PRIMARY KEY autoincrement,                -- 设置主键
                        logId integer,                -- 外键 log表的id
                        SQLStr500 VARCHAR(500),       --前500个字符
                        SQLStr TEXT--字符串后缀       --超过500个字符才有用
                    );
                ");
        }
    }
}
